package com.gljx.web.dao;

import com.gljx.web.Entity.*;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

@Component
public interface SharecarthreeregMapper {
    int deleteByPrimaryKey(String fid);

    int insert(Sharecarthreereg record);

    int insertSelective(Sharecarthreereg record);

    Sharecarthreereg selectByPrimaryKey(String fid);

    int updateByPrimaryKeySelective(Sharecarthreereg record);

    int updateByPrimaryKey(Sharecarthreereg record);

    //查询科目三分车列表的已经分车的人
    List<Sharecarthreereg> selThreeCarAsPeo(String cflcsjid);

    //通过练车时间id 学生id 查询 学生状态
    Long selectStudentstate(@Param("cflcsjid") String cflcsjid, @Param("studentid") String studentid);

    List<Sharecarthreeregentry> selectSharecarthreeregAsXls(@Param("fnumber") String fnumber, @Param("fdescription") String fdescription,
                                                            @Param("cfstudentname") String cfstudentname, @Param("beginTime") String beginTime,
                                                            @Param("endTime") String endTime, @Param("fcompanyid") String fcompanyid);

    Sharecarthreereg selectByFnumber(String fnumber);
}